Bentley Map V8i (SELECTseries 10) Help

To Embed a SQL List

  1. After selecting the Embedded SQL list option, select OK.
  2. Under the newly created property, select the DomainList node. Key in an SQL statement as shown. Including an ORDER BY clause if the domain list should be sorted.


  3. Selecting the cache option will cause the SELECT statement to be run once when first used during a session resulting in improved performance. If not selected, the SELECT statement will be run each time it is accessed.
  4. Select the property node and enter values as shown.


  5. The Value Col Name is the column from the query that will actually be stored in the property.
  6. The Edit Column name is the column from the query that will be displayed in the combo box.
  7. Also provide a Tool Tip to prompt the user on what type of entry is expected.